5.2 Exemplary Configuration for Servicing Two RDBMS Jobs

  1. Drawing of network connection for two RDBMS jobs:


  2. Basic information about the exemplary network machines:


    127.0.0.1...............localhost
    #
    # local interfaces
    192.9.2.2....................russell..........loghost
    192.9.3.2....................russell-1
    192.9.4.2....................russell-2
    #
    # Other HA server interfaces
    192.9.2.1...................peter
    192.9.3.1....................peter-1
    192.9.4.1....................peter-2
    #
    # HA Active interfaces
    192.9.3.9....................act1
    192.9.4.9....................act2
    #
    # RDBMS client
    192.9.3.10..................client
    192.9.4.10..................client-1


    The next table provides the information about them that you can see from the "peter" machine in its /etc/hosts.


    127.0.0.1...............localhost
    #
    # local interfaces
    192.9.2.1....................peter..........loghost
    192.9.3.1....................peter-1
    192.9.4.1....................peter-2
    #
    # Other HA server interfaces
    192.9.2.2....................russell
    192.9.3.2....................russell-1
    192.9.4.2....................russell-2
    #
    # HA Active interfaces
    192.9.3.9....................act1
    192.9.4.9....................act2
    #
    # RDBMS client
    192.9.3.10............................client
    192.9.4.10............................client-1


    The next table provides the information about them that you can see from the client machine in its /etc/hosts.


    127.0.0.1...............localhost
    #
    192.9.3.10..................client loghost
    192.9.4.10..................client-1
    # HA Active interfaces
    192.9.3.9....................act1
    192.9.4.9....................act2

  3. Exemplary configuration for two RDBMS jobs (e.g., Sybase and Oracle):

    # HA configuration file
    #
    #################################
    #................License Definition...................#
    #################################
    #
    LICENSE=russell:6BD84BC01095F57A
    LICENSE=peter:EAFEF623F7F970AF
    SERIAL=russell:1234567890123456
    SERIAL=peter:1234567890123456
    DATE=russell:03201996
    DATE=peter:03201996
    #
    #
    #################################
    #..................Node Definition....................#
    #################################
    #
    HOST_NODE=russell,peter
    #
    ORGINAL_IP=russell:le0:russell,le1:russell-1,le2:russell-2
    ORGINAL_IP=peter:le0:peter,le1:peter-1,le2:peter
    ORGINAL_ETHER=russell:8:0:20:1a:ab:8e
    ORGINAL_ETHER=peter:8:0:20:1b:cd:99
    #
    #
    #################################
    #.................Job Definition........................#
    #################################
    #
    JOB_NAME=sybase,oracle
    #
    JOB=sybase
    #
    ACT_NODE=russellACT_LAN=le1ACT_IP=act1
    #
    SHARE_DISK=/dev/dsk/c1t4d0s3
    MOUNT_POINTER=/sybase#
    STANDBY_NODE=peter
    STANDBY_LAN=le1
    STANDBY_DISK=/dev/dsk/c1t4d0s3
    #
    #
    JOB=oracle
    #
    ACT_NODE=peter
    ACT_LAN=le2
    ACT_IP=act2
    #
    SHARE_DISK=/dev/dsk/c1t4d0s6
    MOUNT_POINTER=/oracle
    #
    STANDBY_NODE=russell
    STANDBY_LAN=le2
    STANDBY_DISK=/dev/dsk/c1t4d0s6
    #
    #
    #################################
    #................Misc. Definition..................... #
    #################################
    #
    HEART_BEAT=russell:le0
    HEART_BEAT=peter:le0
    #
    ALIVE_CHECK_TIME=8
    DEVICE_CHECK_TIME=10
    SYNC_DISK_TIME=20
    #
    ##end

    Notes:
    1. With this configuration, client should use act1 to access Sybase and act2 Oracle.
    2. You should have the following four files in /usr/HA/ha_file.
        sybase_start, sybase_stop; oracle_start, oracle_stop
    3. Refer to the section "Edit sybase_start to start sybase dependent applications" to edit all these four files.
    4. The ACT_LAN for Oracle cannot be set as le0.

Table of ContentsSec. 5-1 sec. 5-2